<?

$fs_exp_rep_reports = new Fieldset (array (
	db_conn=>$_GLOBAL_DBH,
	relation=>"exp_rep_reports",
	title=>"Expense Report",
	fieldset=>array (
		array (name=>"id",label=>"ID",type=>"numeric",
				value=>$_REQUEST["report_id"],
				input=>"hidden",primary_key=>true),
		array (name=>"employee_id",label=>"Employee ID",type=>"numeric",
				relation=>array(foreign=>"exp_rep_employees",key=>"id",
				field=>"name"),
				input=>"select",
				options=>"_app_select_query",
				options_params=>"SELECT id,name FROM exp_rep_employees",
				columns=>array (key=>"id",value=>"name"),
		),
		array (name=>"expense_type_id",label=>"Expense Type",type=>"numeric",
				relation=>array(foreign=>"exp_rep_types",key=>"id",
				field=>"name"),
				input=>"select",
				options=>"_app_select_query",
				options_params=>"SELECT id,name FROM exp_rep_types",
				columns=>array (key=>"id",value=>"name"),
		),
		array (name=>"expense_report",label=>"Expense Report",type=>"alphanumeric",
				input=>"text"),
		array (name=>"expense_report_description",label=>"Expense Description",type=>"alphanumeric",
				input=>"text"),
		array (name=>"date_submitted",label=>"Date Submitted",type=>"any",
				input=>"date",value=>_app_date("date_submitted")),
		array (name=>"advance_amount",label=>"Advanced Amount",type=>"decimal",
				input=>"field", optional=>true),
		array (name=>"dpartment_charged",label=>"Department Charged",type=>"any",
				input=>"field"),
		array (name=>"paid",label=>"Paid",type=>"any",
				input=>"field"),
	),
));

$fs_exp_rep_reports->parse ();

?>
